<div class="row">
    <div class="header">
        <h2>
            <span>Sách mới</span>
        </h2>
    </div>

    <div class="row">
        <ul class="homepage-books">
            <?php
                    $sql = "SELECT * FROM Sach WHERE BiXoa = 0 AND MaTrangThaiSach = 1";
                    $result = DataProvider::ExecuteQuery($sql);
                    while($row = mysql_fetch_array($result)){

            ?>
            <li>
                <a href="index.php?a=6&id=<?php echo $row["MaSach"]; ?> " class="coupon-thumb">
                    <img src="<?php echo $row["HinhURL"]; ?>" alt="<?php echo $row["TenSach"]; ?>" title="<?php echo $row["TenSach"]; ?>" />
                    <div class="coupon-inner">
                        <h5 class="coupon-title"><?php echo $row["TenSach"]; ?></h5>
                        <p class="coupon-desciption"><?php echo $row["TacGia"]; ?></p>
                        <div class="coupon-meta">
                            <div class="coupon-price">
                                <span class="coupon-new-price">Chi tiết</span>
                            </div>
                        </div>
                    </div>
                </a>
            </li>
            <?php
                }
            ?>
        </ul>
    </div>

</div>

<div class="row">
    <div class="header-pink">
        <h2>
            <span>Sách tiêu biểu</span>
        </h2>
    </div>

    <div class="row">
        <ul class="homepage-books">
            <?php
                    $sql = "SELECT * FROM Sach WHERE BiXoa = 0 AND MaTrangThaiSach = 2";
                    $result = DataProvider::ExecuteQuery($sql);
                    while($row = mysql_fetch_array($result)){

            ?>
            <li>
                <a href="index.php?a=6&id=<?php echo $row["MaSach"]; ?> " class="coupon-thumb">
                    <img src="<?php echo $row["HinhURL"]; ?>" alt="<?php echo $row["TenSach"]; ?>" title="<?php echo $row["TenSach"]; ?>" />
                    <div class="coupon-inner">
                        <h5 class="coupon-title"><?php echo $row["TenSach"]; ?></h5>
                        <p class="coupon-desciption"><?php echo $row["TacGia"]; ?></p>
                        <div class="coupon-meta">
                            <div class="coupon-price">
                                <span class="coupon-new-price">Chi tiết</span>
                            </div>
                        </div>
                    </div>
                </a>
            </li>
            <?php
                }
            ?>
        </ul>
    </div>

</div>
<div class="row">
    <div class="header-inter">
        <h2>
            <span>Sách ngoại văn</span>
        </h2>
    </div>
    <div class="row">
        <ul class="homepage-books">
            <?php
                    $sql = "SELECT * FROM Sach WHERE BiXoa = 0 AND MaTrangThaiSach = 3";
                    $result = DataProvider::ExecuteQuery($sql);
                    while($row = mysql_fetch_array($result)){

            ?>
            <li>
                <a href="index.php?a=6&id=<?php echo $row["MaSach"]; ?> " class="coupon-thumb">
                    <img src="<?php echo $row["HinhURL"]; ?>" alt="<?php echo $row["TenSach"]; ?>" title="<?php echo $row["TenSach"]; ?>" />
                    <div class="coupon-inner">
                        <h5 class="coupon-title"><?php echo $row["TenSach"]; ?></h5>
                        <p class="coupon-desciption"><?php echo $row["TacGia"]; ?></p>
                        <div class="coupon-meta">
                            <div class="coupon-price">
                                <span class="coupon-new-price">Chi tiết</span>
                            </div>
                        </div>
                    </div>
                </a>
            </li>
            <?php
                }
            ?>

        </ul>
    </div>
</div>
